/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package pos.system.database;

/**
 *
 * @author shameera
 */
public class DBConstant {
    
//    public static final String DATABASE= "`pos_db`";
    public static final String DATABASE= "`leafpos`";
    public static final String LEAFPOS_DATABASE = "leafpos";
    public static final String DEFAULT_USERNAME = "dbadmin";
    public static final String DEFAULT_PASSWORD = "VbcPwcaytATKSemr";
    
    public static final String STOCK_TABLE = "stock";
    public static final String STOCK_TABLE_DB_STRING= "`stock`";
    public static final String STOCK_CODE= "CODE";
    public static final String STOCK_NAME= "NAME";
    public static final String STOCK_SELLER= "SELLER";
    public static final String STOCK_QTY= "QTY";
    public static final String STOCK_UNIT_PRICE= "UNIT_PRICE";
    public static final String STOCK_DATE= "DATE";
    public static final String STOCK_TIMESTAMP= "TIMESTAMP";
    public static final String STOCK_NA = "N/A";
    

    public static final String ORDER_TABLE= "order";
    public static final String ORDER_TABLE_DB_STRING= "`order`";
    public static final String ORDER_INVOICE = "INVOICE";
    public static final String ORDER_ITEM_ID = "ITEM_ID";
    public static final String ORDER_CODE = "CODE";
    public static final String ORDER_ITEM_NAME = "ITEM_NAME";
    public static final String ORDER_QTY = "QTY";
    public static final String ORDER_SELLER = "SELLER";
    public static final String ORDER_UNIT_PRICE = "UNIT_PRICE";
    
    
    public static final String INVOICE_TABLE= "invoice";
    public static final String INVOICE_TABLE_DB_STRING= "`invoice`";
    public static final String INVOICE_INVOICE = "INVOICE";
    public static final String INVOICE_USER = "USER";
    public static final String INVOICE_ITEM_COUNT = "ITEM_COUNT";
    public static final String INVOICE_TOTAL = "TOTAL";
    public static final String INVOICE_DATE = "DATE";
    public static final String INVOICE_TIMESTAMP = "TIMESTAMP";
    
    public static final String CREDENTIAL_TABLE= "credential";
    public static final String CREDENTIAL_TABLE_DB_STRING= "`credential`";
    public static final String CREDENTIAL_USERNAME= "USERNAME";
    public static final String CREDENTIAL_PASSWORD= "PASSWORD";
    public static final String CREDENTIAL_ROLE= "ROLE";
    public static final String CREDENTIAL_DATE= "DATE";
    
    public static final String ROLE_TABLE = "role";
    public static final String ROLE_TABLE_DB_STRING = "`role`";
    public static final String ROLE_ID = "ID";
    public static final String ROLE_NAME = "NAME";
    public static final String ROLE_PERMISSION = "PERMISSION";
    
}
